﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Admin_DevWork_Query.aspx.cs" Inherits="Admin_DevWork_Query" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title></title>
    <meta charset="UTF-8">
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />
    <link rel="stylesheet" href="./css/font.css">
    <link rel="stylesheet" href="./css/xadmin.css">
    <link rel="stylesheet" href="./css/gridview.css">
    <script type="text/javascript" src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>
    <script type="text/javascript" src="./lib/layui/layui.js" charset="utf-8"></script>
    <script type="text/javascript" src="./js/xadmin.js"></script>
    <script type="text/javascript" src="./js/cookie.js"></script>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <style>
        .all{
            width:95%;
            margin-left:2.5%
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <br />
        <div class="all"> 
     <div class="layui-container" style="margin-top: 10px; margin-bottom: 10px;">
       (请输入相关信息以提升查询准确度，<b><font style="color: red">非必填</font></b>)
       </div>
             <%--  <table>
                <tr>
                    <td>查询</td>
                    <td>
                        <div style="font-size: small">--%>
                            
                       <%--   
                    </td>
                    <td>：</td>
                </tr>
            </table>
        </div> --%>
        <div class="layui-container">
            <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px;">
                <div class="layui-col-md4" style="margin-right: 10px">
                    <asp:TextBox ID="Fnum" runat="server" class="layui-input" placeholder="请输入要查找的账户名"></asp:TextBox>
                </div>
                <div class="layui-col-md4" style="margin-left: 10px">
                    <asp:Button ID="Button1" runat="server" Text="查询" class="layui-btn" OnClick="Button1_Click" />
                 </div>
             </div>
            <asp:Label ID="Label1" runat="server" Text=""></asp:Label>             
  </div>
               <%--   <div class="layui-col-md4">
                </div>
            </div>
       
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringProManage %>" DeleteCommand="update userd set [flag]=0 where [uername]=@uername" SelectCommand="SELECT [uername], [password], [name], [sex], [tel], [email] FROM [Users] WHERE ([uername]  LIKE '%' + @uername + '%')and([usertype]=0)and([flag]=1)

">
            <DeleteParameters>
                <asp:Parameter Name="uername" />
            </DeleteParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="Fnum" Name="uername" PropertyName="Text" Type="String" DefaultValue="%" />
            </SelectParameters>
        </asp:SqlDataSource>
        <div class="layui-container">
            <asp:GridView ID="GridView1" Class="GridView" runat="server" AutoGenerateColumns="False" DataKeyNames="uername" DataSourceID="SqlDataSource1" Visible="False">
                <Columns>
                    <asp:BoundField DataField="uername" HeaderText="登录账户名" ReadOnly="True" SortExpression="uername" />
                    <asp:BoundField DataField="password" HeaderText="登录密码" SortExpression="password" />
                    <asp:BoundField DataField="name" HeaderText="姓名" SortExpression="name" />
                    <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />
                    <asp:BoundField DataField="tel" HeaderText="电话" SortExpression="tel" />
                    <asp:BoundField DataField="email" HeaderText="邮箱" SortExpression="email" />
                    <asp:HyperLinkField DataNavigateUrlFields="uername" DataNavigateUrlFormatString="Admin_DevWork_Details.aspx?id={0}" HeaderText="详细信息" Text="查看" />
                </Columns>
            </asp:GridView>
        </div>
--%>


</div>
    </form>
</body>
</html>
